CREATE VIEW [dbo].[vGroupInfo] WITH SCHEMABINDING
AS
SELECT t.[GroupTypeKey], t.[GroupTypeName], t.[GroupTypeDesc], t.[IsSimpleGroup], t.[IsDateLimited],
       g.[GroupKey], g.[Name] AS [GroupName], g.[Description] AS [GroupDesc], g.[IsAutoGenerated], g.[GroupStatusCode], g.[InheritRolesFlag],
       m.[GroupMemberKey], m.[MemberContactKey], m.[IsActive] AS [IsActiveMember], m.[JoinDate], m.[DropDate]
  FROM [dbo].[GroupMember] m
       INNER JOIN [dbo].[GroupMain] g ON m.[GroupKey] = g.[GroupKey]
       INNER JOIN [dbo].[GroupTypeRef] t ON g.[GroupTypeKey] = t.[GroupTypeKey]


GO